Equality of access to public playgrounds for children in the city of Berlin

Data

Lebensweltlich orientierte Räume (LORs) of Berlin - A system by the municipality to split Berlin into smaller areas. The finest granularity are 542 “Planungsräume” (PLRs). [daten.berlin.de]

Inhabitants of Berlin 06/2021 - Number of inhabitants per PLR, split up by age [statistik-berlin-brandenburg.de]

Children in poverty 12/2020 - Percentage of children living in poverty per PLR, taken out of the report on social city development [daten.berlin.de]

Playgrounds in Berlin as of March 2023 - A list of publicly owned playgrounds accessible to every citizen [daten.berlin.de]

Hypothesis

With this data, I can analyze if playground access is distributed fairly among the population of children living in the city.

I can check how many playgrounds and how much playarea is available to each child. I can further break down the analysis to each PLR and calculate the availability of playgrounds relative to the amount of children living said PLR. Finally, I can compare these values with regard to different levels of child poverty in each PLR.

Importance

Cooperation, exploration, play and physical exercise are important factors for a healthy development of children. Part of a municipality’s obligation is to ensure and foster the healthy development of its population and minor citizens. Public playgounds are an important part of these efforts. But public playgrounds are heterogenous in size and location as is the distribution of the population of children the playgrounds are meant for. Families of children living in poverty might not have the political leverage to ensure equal access and availability of playgrounds for their children. Analyzing and reporting on the fairness of distribution and accessability of these public efforts is the responsibility of the press. Informing the public on the outcome of public investments serves as a control mechanism of power.

Main findings

Visualizations

Choropleth of playarea per child for each PLR in Berlin
This Chloropleth allows for a comparison of the available playarea for each child in the respective PLRs. There is no clear geographic pattern.

Scatterplot of playarea per child per PLR relative to child poverty in that PLR
This Figure shows that there is no clear correlation between the playarea available to each child per PLR and the child poverty percentage of that PLR.

Boxplot of playarea per child per PLR
Visualisation of the differences in playground area per child across all PLRs. The blue box represents the PLRs with values in between the first and third quartile (interquartile range). Within that box, 50 percent of values are located.

Chloropleth of playarea relative to toal area for each PLR in Berlin
This map shows how much of the total area of each PLR is dedicated as playarea.

Outlook

To pour this analysis into an article, I would drastically reduce the complexity of visualisations and numbers provided. This is the output of a data analysis and nowhere near an article presentable to the average audience. The lack of data leaves questions open about the quality of playgrounds, the accessibilty of playgrounds via public transportation or other means of transportation. Instead of mulitple figures and plots, I would provide an interactive map, so the reader is able to familiarize themself with the findings.


This could be a start:

Limitations

Expand allBack to topGo to bottom